package study.javaee.practice.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import study.javaee.practice.entity.Draw;

import java.util.List;

@Mapper
public interface DrawDao extends BaseMapper<Draw> {
    @Select("Select log_type As state,count(log_type) As num From log Group By log_type order By log_type")
    public List<Draw> drawPieLog();
    @Select("Select  state,count(state) As num From project Group By state order By state")
    public List<Draw> drawProject();
    @Select("Select  state,count(state) As num From project_join_apply Group By state order By state")
    public List<Draw> drawProjectJoinApply();
}
